Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5693
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	533.8 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Alerts

`df_index` is highly correlated with `customer_id` and 2 other fields	High correlation
`gross_revenue` is highly correlated with `purchases_quantity` and 4 other fields	High correlation
`recency_days` is highly correlated with `df_index` and 2 other fields	High correlation
`purchases_quantity` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qt_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`max_recency` is highly correlated with `df_index` and 2 other fields	High correlation
`qt_returns` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`purchased_returned_diff` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`frequency` is highly correlated with `purchases_quantity`	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`customer_id` is highly correlated with `df_index` and 2 other fields	High correlation
`gross_revenue` is highly skewed (γ1 = 21.65111285)	Skewed
`basket_size` is highly skewed (γ1 = 23.05322796)	Skewed
`avg_ticket` is highly skewed (γ1 = 53.23956349)	Skewed
`qt_returns` is highly skewed (γ1 = 51.51976197)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`qt_returns` has 4190 (73.6%) zeros	Zeros
`purchased_returned_diff` has 115 (2.0%) zeros	Zeros

Reproduction

Analysis started	2022-11-18 03:03:20.317031
Analysis finished	2022-11-18 03:03:49.840412
Duration	29.52 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	5693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2897.769542

Minimum	0
Maximum	5786
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	292.6
Q1	1457
median	2900
Q3	4342
95-th percentile	5495.4
Maximum	5786
Range	5786
Interquartile range (IQR)	2885

Descriptive statistics

Standard deviation	1668.431283
Coefficient of variation (CV)	0.5757639656
Kurtosis	-1.195986729
Mean	2897.769542
Median Absolute Deviation (MAD)	1443
Skewness	-0.003756457883
Sum	16497002
Variance	2783662.945
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3891	1	< 0.1%
3867	1	< 0.1%
3866	1	< 0.1%
3865	1	< 0.1%
3864	1	< 0.1%
3863	1	< 0.1%
3862	1	< 0.1%
3861	1	< 0.1%
3860	1	< 0.1%
Other values (5683)	5683	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5786	1	< 0.1%
5785	1	< 0.1%
5784	1	< 0.1%
5783	1	< 0.1%
5782	1	< 0.1%
5781	1	< 0.1%
5780	1	< 0.1%
5779	1	< 0.1%
5778	1	< 0.1%
5777	1	< 0.1%

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	5693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16429.71158

Minimum	12346
Maximum	21997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	12346
5-th percentile	12698.8
Q1	14288
median	16227
Q3	18211
95-th percentile	21020.8
Maximum	21997
Range	9651
Interquartile range (IQR)	3923

Descriptive statistics

Standard deviation	2563.802211
Coefficient of variation (CV)	0.1560466962
Kurtosis	-0.8649309179
Mean	16429.71158
Median Absolute Deviation (MAD)	1963
Skewness	0.3130952856
Sum	93534348
Variance	6573081.777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
20399	1	< 0.1%
16498	1	< 0.1%
13745	1	< 0.1%
15584	1	< 0.1%
20377	1	< 0.1%
20376	1	< 0.1%
20375	1	< 0.1%
20374	1	< 0.1%
15578	1	< 0.1%
Other values (5683)	5683	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
21997	1	< 0.1%
21996	1	< 0.1%
21995	1	< 0.1%
21994	1	< 0.1%
21993	1	< 0.1%
21992	1	< 0.1%
21988	1	< 0.1%
21987	1	< 0.1%
21984	1	< 0.1%
21983	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5449
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1803.12215

Minimum	0.42
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	13.128
Q1	236.18
median	612.78
Q3	1571.19
95-th percentile	5326.398
Maximum	279138.02
Range	279137.6
Interquartile range (IQR)	1335.01

Descriptive statistics

Standard deviation	7884.351281
Coefficient of variation (CV)	4.372610741
Kurtosis	610.3336303
Mean	1803.12215
Median Absolute Deviation (MAD)	478.74
Skewness	21.65111285
Sum	10265174.4
Variance	62162995.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
2.95	8	0.1%
4.95	8	0.1%
1.25	8	0.1%
12.75	7	0.1%
1.65	7	0.1%
3.75	7	0.1%
5.95	6	0.1%
4.25	6	0.1%
7.5	6	0.1%
Other values (5439)	5621	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.8115229

Minimum	0
Maximum	373
Zeros	38
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	22
median	71
Q3	199
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	177

Descriptive statistics

Standard deviation	111.591303
Coefficient of variation (CV)	0.9553107448
Kurtosis	-0.6395565525
Mean	116.8115229
Median Absolute Deviation (MAD)	61
Skewness	0.8157757981
Sum	665008
Variance	12452.6189
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	78	1.4%
15	66	1.2%
Other values (294)	4818	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	0.7%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

purchases_quantity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	57
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.471631829

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	205
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.807831418
Coefficient of variation (CV)	1.960988882
Kurtosis	300.7030961
Mean	3.471631829
Median Absolute Deviation (MAD)	0
Skewness	13.16111093
Sum	19764
Variance	46.34656861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2869	50.4%
2	825	14.5%
3	503	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	70	1.2%
11	54	0.9%
Other values (47)	332	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2869	50.4%
2	825	14.5%
3	503	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	70	1.2%
10	54	0.9%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1843
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.8603548

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	106
median	317
Q3	806
95-th percentile	2943.4
Maximum	196844
Range	196843
Interquartile range (IQR)	700

Descriptive statistics

Standard deviation	4429.497205
Coefficient of variation (CV)	4.525157427
Kurtosis	785.219949
Mean	978.8603548
Median Absolute Deviation (MAD)	253
Skewness	23.05322796
Sum	5572652
Variance	19620445.49
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
7	20	0.4%
Other values (1833)	5255	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	114	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.4%
8	18	0.3%
9	7	0.1%
10	17	0.3%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

qt_products
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	529
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.61233093

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	14
median	41
Q3	106
95-th percentile	332.4
Maximum	7838
Range	7837
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	210.2090138
Coefficient of variation (CV)	2.269773492
Kurtosis	508.9425687
Mean	92.61233093
Median Absolute Deviation (MAD)	33
Skewness	17.7059352
Sum	527242
Variance	44187.82948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	256	4.5%
2	148	2.6%
3	110	1.9%
10	101	1.8%
6	99	1.7%
9	92	1.6%
5	90	1.6%
4	86	1.5%
7	84	1.5%
11	83	1.5%
Other values (519)	4544	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	256	4.5%
2	148	2.6%
3	110	1.9%
4	86	1.5%
5	90	1.6%
6	99	1.7%
7	84	1.5%
8	80	1.4%
9	92	1.6%
10	101	1.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5589	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5501
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.6078878

Minimum	0.42
Maximum	77183.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	3.459660952
Q1	7.95
median	15.84941176
Q3	21.96956522
95-th percentile	76.32
Maximum	77183.6
Range	77183.18
Interquartile range (IQR)	14.01956522

Descriptive statistics

Standard deviation	1281.784009
Coefficient of variation (CV)	23.47250664
Kurtosis	2950.232891
Mean	54.6078878
Median Absolute Deviation (MAD)	7.485911765
Skewness	53.23956349
Sum	310882.7053
Variance	1642970.246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.75	11	0.2%
4.95	10	0.2%
1.25	9	0.2%
2.95	9	0.2%
7.95	8	0.1%
1.65	7	0.1%
8.25	7	0.1%
12.75	7	0.1%
3.35	6	0.1%
4.15	6	0.1%
Other values (5491)	5613	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	3	0.1%
0.535	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.8371428571	1	< 0.1%
0.84	2	< 0.1%
0.85	3	0.1%
1.002222222	1	< 0.1%
1.02	1	< 0.1%
1.03875	1	< 0.1%

Value	Count	Frequency (%)
77183.6	1	< 0.1%
56157.5	1	< 0.1%
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3861	1	< 0.1%
3202.92	1	< 0.1%
3096	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
1001.2	1	< 0.1%

max_recency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	365
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.4753206

Minimum	0
Maximum	373
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	21
Q1	67
median	135
Q3	225
95-th percentile	351
Maximum	373
Range	373
Interquartile range (IQR)	158

Descriptive statistics

Standard deviation	100.2344246
Coefficient of variation (CV)	0.657381301
Kurtosis	-0.7722855338
Mean	152.4753206
Median Absolute Deviation (MAD)	75
Skewness	0.5157041008
Sum	868042
Variance	10046.93988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
154	44	0.8%
63	44	0.8%
213	40	0.7%
42	37	0.6%
53	35	0.6%
64	35	0.6%
101	35	0.6%
119	34	0.6%
50	34	0.6%
56	34	0.6%
Other values (355)	5321	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.1%
1	11	0.2%
2	7	0.1%
3	13	0.2%
4	18	0.3%
5	10	0.2%
7	15	0.3%
8	7	0.1%
9	16	0.3%
10	23	0.4%

Value	Count	Frequency (%)
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	16	0.3%
365	20	0.4%
364	12	0.2%
363	1	< 0.1%

qt_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	214
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.91779378

Minimum	0
Maximum	80995
Zeros	4190
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	38
Maximum	80995
Range	80995
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1474.979277
Coefficient of variation (CV)	31.43752419
Kurtosis	2717.510193
Mean	46.91779378
Median Absolute Deviation (MAD)	0
Skewness	51.51976197
Sum	267103
Variance	2175563.868
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
6	78	1.4%
5	61	1.1%
12	52	0.9%
7	44	0.8%
8	43	0.8%
Other values (204)	712	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
5	61	1.1%
6	78	1.4%
7	44	0.8%
8	43	0.8%
9	41	0.7%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9360	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%

purchased_returned_diff
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	1852
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	12
Infinite (%)	0.2%
Mean	-inf

Minimum	-inf
Maximum	12.18870266
Zeros	115
Zeros (%)	2.0%
Negative	12
Negative (%)	0.2%
Memory size	44.6 KiB

Quantile statistics

Minimum	-inf
5-th percentile	1.386294361
Q1	4.644390899
median	5.743003188
Q3	6.678342115
95-th percentile	7.958435846
Maximum	12.18870266
Range	inf
Interquartile range (IQR)	2.033951216

Descriptive statistics

Standard deviation	nan
Coefficient of variation (CV)	nan
Kurtosis	nan
Mean	-inf
Median Absolute Deviation (MAD)	1.008098281
Skewness	nan
Sum	-inf
Variance	nan
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115	2.0%
0.6931471806	71	1.2%
1.098612289	51	0.9%
1.386294361	49	0.9%
1.609437912	35	0.6%
1.791759469	29	0.5%
2.48490665	24	0.4%
4.477336814	22	0.4%
4.276666119	22	0.4%
1.945910149	20	0.4%
Other values (1842)	5255	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-inf	12	0.2%
0	115	2.0%
0.6931471806	71	1.2%
1.098612289	51	0.9%
1.386294361	49	0.9%
1.609437912	35	0.6%
1.791759469	29	0.5%
1.945910149	20	0.4%
2.079441542	18	0.3%
2.197224577	7	0.1%

Value	Count	Frequency (%)
12.18870266	1	< 0.1%
11.25085916	1	< 0.1%
11.24958472	1	< 0.1%
11.14245581	1	< 0.1%
11.06857399	1	< 0.1%
11.0511122	1	< 0.1%
11.03178808	1	< 0.1%
10.96856029	1	< 0.1%
10.95103459	1	< 0.1%
10.8075235	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1225
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5471335777

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.01102941176
Q1	0.02492211838
median	1
Q3	1
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.9750778816

Descriptive statistics

Standard deviation	0.550291935
Coefficient of variation (CV)	1.005772552
Kurtosis	139.1568734
Mean	0.5471335777
Median Absolute Deviation (MAD)	0
Skewness	4.860114251
Sum	3114.831458
Variance	0.3028212137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2877	50.5%
2	47	0.8%
0.0625	18	0.3%
0.02777777778	17	0.3%
0.02380952381	16	0.3%
0.08333333333	15	0.3%
0.09090909091	15	0.3%
0.02941176471	14	0.2%
0.03448275862	14	0.2%
0.02127659574	13	0.2%
Other values (1215)	2647	46.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	5	0.1%
2	47	0.8%
1.142857143	1	< 0.1%
1	2877	50.5%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5308310992	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	purchases_quantity	basket_size	qt_products	avg_ticket	max_recency	qt_returns	purchased_returned_diff	frequency
0	0	17850	5391.21000	372.00000	34.00000	1733.00000	297.00000	18.15222	372.00000	40.00000	7.43426	17.00000
1	1	13047	3232.59000	56.00000	9.00000	1390.00000	171.00000	18.90404	71.00000	35.00000	7.21156	0.02830
2	2	12583	6705.38000	2.00000	15.00000	5028.00000	232.00000	28.90250	73.00000	50.00000	8.51278	0.04032
3	3	13748	948.25000	95.00000	5.00000	439.00000	28.00000	33.86607	137.00000	0.00000	6.08450	0.01792
4	4	15100	876.00000	333.00000	3.00000	80.00000	3.00000	292.00000	333.00000	22.00000	4.06044	0.07317
5	5	15291	4623.30000	25.00000	14.00000	2102.00000	102.00000	45.32647	78.00000	29.00000	7.63675	0.04011
6	6	14688	5630.87000	7.00000	21.00000	3621.00000	327.00000	17.21979	48.00000	399.00000	8.07776	0.05722
7	7	17809	5411.91000	16.00000	12.00000	2057.00000	61.00000	88.71984	70.00000	41.00000	7.60887	0.03352
8	8	15311	60767.90000	0.00000	91.00000	38194.00000	2379.00000	25.54346	21.00000	474.00000	10.53795	0.24332
9	9	16098	2005.63000	87.00000	7.00000	613.00000	67.00000	29.93478	87.00000	0.00000	6.41836	0.02439

Last rows

	df_index	customer_id	gross_revenue	recency_days	purchases_quantity	basket_size	qt_products	avg_ticket	max_recency	purchased_returned_diff	frequency
5683	5777	21988	4839.42000	1.00000	1.00000	1074.00000	62.00000	78.05516	1.00000	6.97915	1.00000
5684	5778	13298	360.00000	1.00000	1.00000	96.00000	2.00000	180.00000	1.00000	4.56435	1.00000
5685	5779	14569	227.39000	1.00000	1.00000	79.00000	12.00000	18.94917	1.00000	4.36945	1.00000
5686	5780	21992	17.90000	1.00000	1.00000	14.00000	7.00000	2.55714	1.00000	2.63906	1.00000
5687	5781	21993	3.35000	1.00000	1.00000	2.00000	2.00000	1.67500	1.00000	0.69315	1.00000
5688	5782	21994	5699.00000	1.00000	1.00000	1747.00000	634.00000	8.98896	1.00000	7.46566	1.00000
5689	5783	21995	6756.06000	0.00000	1.00000	2010.00000	730.00000	9.25488	0.00000	7.60589	1.00000
5690	5784	21996	3217.20000	0.00000	1.00000	654.00000	59.00000	54.52881	0.00000	6.48311	1.00000
5691	5785	21997	3950.72000	0.00000	1.00000	731.00000	217.00000	18.20608	0.00000	6.59441	1.00000
5692	5786	12713	794.55000	0.00000	1.00000	505.00000	37.00000	21.47432	0.00000	6.22456	1.00000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows